Use sms_p
ALTER USER SoapGate WITH LOGIN = SoapGate;
ALTER USER sms WITH LOGIN = sms;
create USER Terminal for LOGIN  Terminal;
CREATE ROLE [TerminalRole] AUTHORIZATION [dbo]
EXEC dbo.sp_addrolemember @rolename=N'TerminalRole', @membername=N'Terminal'
EXEC dbo.sp_addrolemember @rolename=N'Executer', @membername=N'Terminal'
GRANT execute ON SCHEMA :: Terminal TO TerminalRole;


create USER RegClaimer for LOGIN  RegClaimer;
EXEC dbo.sp_addrolemember @rolename=N'Browser', @membername=N'RegClaimer'
GRANT execute ON sp_AutomatRegistration TO RegClaimer;
